package com.ddy.test;


public class SQL {
	
	public static void main(String[] args) {
		/*String[] schools={"第一小学","第二小学","第三小学","营前小学","油石小学","社溪小学",
				"黄埠小学","寺下小学","沿湖小学","陡水小学","蓝田小学","紫阳小学",
				"县职业中专","上犹中学","上犹二中","黄埠中学","寺下中学","社溪中学",
				"油石中学","营前中学","紫阳初中","金盆初中","梅水学校","五指峰学校",
				"中稍学校","金盆小学","平富学校","安和学校","双溪学校","水岩学校",
				"特殊教育学校","城区幼儿园","宝钢希望小学","东山镇备田小学","东山镇茶亭小学","东山镇莲塘小学"};*/
		String[] schools={"会昌中学", "会昌县白鹅初中", "会昌县第二中学", "会昌县第三中学", "会昌县第四中学", "会昌县富城初级中学", "会昌县高排初级中学", 
				"会昌县筠门岭中学", "会昌县麻州初级中学", "会昌县实验学校", "会昌县西江中学", "会昌县晓龙初级中学", "会昌县右水乡初级中学", "会昌县站塘初级中学", 
				"会昌县职业技术学校", "会昌县庄埠初级中学", "会昌县庄口初级中学", "会昌县周田中学", "会昌县永隆初级中学", "会昌县西江石门初中", "会昌县幼儿园", 
				"会昌县小密初级中学", "会昌县中村初中", "会昌县教师进修学校", "会昌县第二幼儿园", "会昌县私立英才学校", "会昌小学", "会昌县特殊教育学校", "会昌县第三小学", 
				"会昌县希望小学", "会昌县第四小学", "会昌县洞头畲族中心学校", "会昌县富城中心小学", "会昌县高排中心小学", "会昌县清溪中心学校", "会昌县小密中心小学", 
				"会昌县永隆百第希望小学", "会昌县右水中心小学", "会昌县站塘中心小学", "会昌县中村国土资源希望小学", "会昌县筠门岭中心小学", "会昌珠兰示范学校", "会昌县白鹅中心小学",
				"会昌县文武坝中心小学", "会昌县长岭中心学校", "会昌县周田中心小学", "会昌县麻州中心小学", "会昌县晓龙中心小学", "会昌县庄口中心小学", "会昌县庄埠中心小学", 
				"会昌县西江中心小学"};
		int j=0;
		for(int i=1;i<=51;i++){
			String code="JXBB00" + i;
			if(i>=10){
				code="JXBB0"+i;		
			}
			//user表
			String s = "('" + j++ + "','00602_608_activity_admin','400@" + code +"',0,now(),now(),NULL),"
					+ "('" + j++ + "','00602_608_admin','400@" + code +"',0,now(),now(),NULL),"
					+ "('" + j++ + "','00602_role_notice_admin','400@" + code +"',0,now(),now(),NULL),"
					+ "('" + j++ + "','00602_103_admin','400@" + code +"',0,now(),now(),NULL),"
					+ "('" + j++ + "','00602_608_activity_admin','400@" + code +"',0,now(),now(),NULL),";
			//INSERT INTO `sys_regionalschool` VALUES ('1@BJ325',1,0,'北师大实验中学',NULL,6,1);
			String school = "('401@" + code + "',1,0,'" + schools[i-1] + "',NULL,6,1),";
			//System.out.println(s);
			System.out.println(school);
			//String name = StringUtil.getUnicodeString(schools[i-1]);
			//System.out.println("JXBA" + code + "=" + name.replace("\\\\", "\\") + " http://10.177.100.6 true \\u8d63\\u5dde\\u5e02\\u4e0a\\u72b9\\u53bf");
		}
	}
}
